Excel Magic Trick 367: Any Number Not Zero = True

Excel Magic Trick 367: Any Number Not Zero = TRUE

Excel Magic Trick 459: Non-Zero numbers = TRUE IF Function logical_test Argument Tricks

Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)

Excel Magic Trick 364: Return First Non-Blank (Array Formula)

Excel Magic Trick 1162: Cell Reference That Point To Empty Cells Evaluate To Zero, IF Function Trick

Excel Magic Trick 370: Conditional Formatting Odd & Even Numbers

Excel Magic Trick 987: LOOKUP Last Number In Column, Excluding Zeroes

Excel Magic Trick 261: Random Num 1- 100 Not Divisible By 3

Excel Magic Trick 499: Does Cell Have Number or Text Formula Solution

Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes.

Excel Magic Trick 1345: Conditionally Format Product Name for No Items Entered in Row (4 Methods)

Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0

Excel Magic Trick 911: Add Leading Zero and Dash, More Examples From Mr Excel & excelisfun Trick 107

Excel Magic Trick 788: Add Numbers After Last Zero

Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text

How To Count Number Of Cells With Nonzero Values In Excel

28 November 2016

Excel Magic Trick 1402 Part 2 Formula to Put Check Mark In Cell If Number Great than 0 without CHAR

Excel Magic Trick 970: Extract Records Where Number is Divisible by 5 (5 Examples)

Excel Magic Trick 1402: Formula to Put Check Mark In Cell If Number Greater Than Zero

Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!